{"id":288,"certificate_template_id":1,"title":"Excel Advanced course - Joburg, Pretoria South Africa - Midrand, Sandton, Johannesburg, South Africa","description":"<p>In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.<\/p>","audience":"<p>This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.<\/p>","prerequisites":"<p>To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel Basic and Microsoft Office Excel Intermediate<\/p>","about":"You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.","durationunits":"Day","outline":"<p>Lesson 1:Working with Multiple Worksheets and Workbooks<strong><br \/><\/strong><\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Use Links and External References<\/li>\r\n<li>Use 3-D References<\/li>\r\n<li>Consolidate Data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 2: Using Lookup Functions and Formula Auditing<strong><br \/><\/strong><\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Use Lookup Functions<\/li>\r\n<li>Trace Cells<\/li>\r\n<li>Watch and Evaluate Formulas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 3: Sharing and Protecting Workbooks<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Collaborate on a Workbook<\/li>\r\n<li>Protect Worksheets and Workbooks<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 4: Automating Workbook Functionality<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Apply Data Validation<\/li>\r\n<li>Search for Invalid Data and Formulas with Errors<\/li>\r\n<li>Work with Macros<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 5: Creating Sparklines and Mapping Data<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create Sparklines<\/li>\r\n<li>Map Data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 6: Forecasting Data<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Determine Potential Outcomes Using Data Tables<\/li>\r\n<li>Determine Potential Outcomes Using Scenarios<\/li>\r\n<li>Use the Goal Seek Feature<\/li>\r\n<li>Forecasting Data Trends<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"Excel_2013_logo.png","meta_desc":"In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.","keywords":"Excel advanced course in Johannesburg\r\nexcel advanced training South Africa,\r\nMicrosoft Excel Advanced Training\r\nExcel Advanced","filename":"excel_advanced_","old_slug":null,"name":"Microsoft Excel: Advanced","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Excel Advanced","bookstock":26,"onorder":7,"expectedorderdate":null,"stock_last_updated":"2017-11-28 08:18:04","accountmanagerid":175,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":66,"internal_comments":null,"created_at":null,"updated_at":"2024-03-11T09:17:52.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":288,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-10-09T07:45:43.000000Z","duration":1,"duration_units":"Day","cost":"2750.00","minimum_delegates":null,"moodle_course_id":66}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":288,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-10-09T07:45:43.000000Z","duration":1,"duration_units":"Day","cost":"2250.00","minimum_delegates":null,"moodle_course_id":66}}]}

ENQUIRY